Prefilter in Crosstab Analyzer

You may wish to filter the data and for simple filters you can use the drop-down arrows on the fields you have chosen for the spreadsheet. For example you may have added States into the column area – you can choose to show only VIC and NSW by ticking these boxes in the drop-down list for States.

Sometimes you may have a more complex filter that you want to apply to the data. For this you may wish to use ‘Prefilter’.

ClosedThis is a Wage Analysis spreadsheet, without Prefilter:

(note that the blue bar at the bottom of the image is blank)

This shows a screenshot of a Wage Analysis - Summary Spreadsheet with no Prefilter applied.

Allowing the Prefilter Option

To enable the filtering option select Options | Filter Toolbar from the toolbar. This will display the Prefilter bar at the bottom of the spreadsheet results.

ClosedThere is a Prefilter button on the right hand side of the bar:

This shows the blue bar with the Prefilter button now available

 

ClosedClick Prefilter to display the Filter Builder window:

This is the Filter builder window, showing no filter.

 

 

Understanding filtering with Prefilter

Building a simple Prefilter

Simple Prefilter results

Other examples of a Prefilter

Creating complex filters with Prefilter

Simple Prefilter results